use adventureworks;
go
Select * from sales.salesorderheader

use adventureworks;
go
select Title, firstname as [First Name], lastname as [Last Name], emailaddress as [Email Addree] from Person.Contact




use adventureworks;
go
select Title, firstname , lastname , emailaddress from Person.Contact


use adventureworks;
go
select Title, firstname , lastname , emailaddress from Person.Contact
WHERE EXISTS
( SELECT * from HumanResources.Employee where Person.Contact.ContactID=HumanResources.Employee.ContactID)